UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K2oCOKOL9uuJdY+HgtmZnvohSMXYAXhW2e30w0UiQec='
WHERE
key_id = 'e081fb5ba1fa09994aba80fc4938afdb17a4118b9ba31ccd9db9a40a73cf125c'
AND (
token = 'K2oCOKOL9uuJdY+HgtmZnvohSMXYAXhW2e30w0UiQec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)