UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VGFAvXbk/Ny8fFHUu4P1zQuKIoqwrb6WoOxSm2in0to='
WHERE
key_id = '9787a513902e03d5ab2d45e0147ee81a4a7af12a4e5d80d605fd17db36e4677b'
AND (
token = 'VGFAvXbk/Ny8fFHUu4P1zQuKIoqwrb6WoOxSm2in0to='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)