UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hDSxxw3SqekmbtRPLTF2kDYFcgAWRfHQRvkHMfhy80I='
WHERE
key_id = 'c52c44d2e91b0ffb143f006ad6f43e4b9693ab3f260a57e0e724dc7503972fe4'
AND (
token = 'hDSxxw3SqekmbtRPLTF2kDYFcgAWRfHQRvkHMfhy80I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)