UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3iHVcXvMz5H6EoI3A+Sr7klVQWFycCVPW7bOqEv64es='
WHERE
key_id = 'cd4203b02b8d83b459a2a7a3e0abf25ccdec59fbb8f1d2c238c64a58d2132a2b'
AND (
token = '3iHVcXvMz5H6EoI3A+Sr7klVQWFycCVPW7bOqEv64es='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)