UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1nth0pw8TxOeNs7CVErQY7xsnz9/WDF2JODCgZqpp4k='
WHERE
key_id = 'bc65bf98284f32a7458918a14eabec37862a88c16773b077e1b7edfff7fd6c7e'
AND (
token = '1nth0pw8TxOeNs7CVErQY7xsnz9/WDF2JODCgZqpp4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)