UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rR5nY/rtmmMwu4t87sCeXH0DcTxxFnPfJsADb5a1UjI='
WHERE
key_id = '49afae6616231073558ca6176dc267a1bd2d01ec2d28cac32c154e252f496f41'
AND (
token = 'rR5nY/rtmmMwu4t87sCeXH0DcTxxFnPfJsADb5a1UjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)