UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S4Z2+jWdA6d3EpK8YOABeZqzg3lpqi4RsAi2VCYwWsw='
WHERE
key_id = 'cdf5f8c20383c7f65632342fa2d3646a50cadbd4def1b9cbc3deadadc8e53e29'
AND (
token = 'S4Z2+jWdA6d3EpK8YOABeZqzg3lpqi4RsAi2VCYwWsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)