UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L7UDJXbJLAojB1cba/OYkrys/GujXAV5OyxN7VOU+ds='
WHERE
key_id = 'c38193991f9ab7b47e74f3d038e7418aa971e8f8da5f9c70cea091b7059cd972'
AND (
token = 'L7UDJXbJLAojB1cba/OYkrys/GujXAV5OyxN7VOU+ds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)