UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n4BZhC31eT61YsZFNOVaOSYNDNJQG8zlfTI8xj0Sh4c='
WHERE
key_id = '48d8d0d64205b1c351b1a03e913df367ee74f0e274c6cccea9de03d2af545f84'
AND (
token = 'n4BZhC31eT61YsZFNOVaOSYNDNJQG8zlfTI8xj0Sh4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)