UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1xXevyWVMNlsgeZlnOO301dZHFtMSd0lfmlCyrLubG0='
WHERE
key_id = 'a5aadb18f9f16c44a67873379044473f6ccefaa8b9e5a4a1345a8853d0cab5c3'
AND (
token = '1xXevyWVMNlsgeZlnOO301dZHFtMSd0lfmlCyrLubG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)