UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '15iSsq10USXLa5PgiuS5xBkHKZ8zHT/TO9bnxSZkiA0='
WHERE
key_id = 'b1e91be8ff578548bf5354df72336443f7b4dc628c9761a8d243fc488be46387'
AND (
token = '15iSsq10USXLa5PgiuS5xBkHKZ8zHT/TO9bnxSZkiA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)