UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3NWfYeoL39b3gdcE700zmSW4G81joMCTcOMwkh7kbmc='
WHERE
key_id = '9ca0037adcf02bfe277866970f5d003b3d60cc4c6c1a138ecaba9d562c3f7665'
AND (
token = '3NWfYeoL39b3gdcE700zmSW4G81joMCTcOMwkh7kbmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)