UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4DpsSiEBt0cL2+aqFCwgv9nx/YJXaNLS8rLHDPuiowY='
WHERE
key_id = 'a16d3a08f439558939405811aeebc4e3b9f4a4dc3e35b49639fd442ee7cd1358'
AND (
token = '4DpsSiEBt0cL2+aqFCwgv9nx/YJXaNLS8rLHDPuiowY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)