UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zOPXgRgfAzd3YA44avbwUfRd3gZaXGRk2HFIXpUyTKw='
WHERE
key_id = '6a4f9a332a41d13828cc880b3490d20e3b266f7f6598594e8449757b671ee4ac'
AND (
token = 'zOPXgRgfAzd3YA44avbwUfRd3gZaXGRk2HFIXpUyTKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)