UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kDgH0YviUxKe2xuPP9nfqzcPcAiiHLSzu4WNLtG3mVM='
WHERE
key_id = '749b5acc92eb3b976e3645d8dfce364a2213baff3fcaf4899413ee8ac10bbbfa'
AND (
token = 'kDgH0YviUxKe2xuPP9nfqzcPcAiiHLSzu4WNLtG3mVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)