UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nXlymqrpEwemd4meOt1Jdiava1iUqeSgPXS6lkYqOgM='
WHERE
key_id = '7e2f3169368e06c9cd9863ed583fdf97d0521be3d377361ac017cd48267ee25e'
AND (
token = 'nXlymqrpEwemd4meOt1Jdiava1iUqeSgPXS6lkYqOgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)