UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gs8j9QoB/eSMIHGYjPW3cPrEPHBAVzp01hA613nMUco='
WHERE
key_id = 'a5cc40cfee19127de3b2da93a2286febf11d4c419853aa07d19b1e2caba83b38'
AND (
token = 'gs8j9QoB/eSMIHGYjPW3cPrEPHBAVzp01hA613nMUco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)