UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g74CDfPEdb+uBHMlTnHJbooIVxH1Rfa7rCRgRFE6q00='
WHERE
key_id = 'e23309d92318a4785733ae7013164b2de6f51fec94e43e052031708ca1c6bcbf'
AND (
token = 'g74CDfPEdb+uBHMlTnHJbooIVxH1Rfa7rCRgRFE6q00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)