UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AsHN4N0aQficdZRNdf1trvE2ezJYVoaWEZwOEj1D+xg='
WHERE
key_id = 'e818f25b7ec9552f5d8aee1ed4daf7bb58523d9f0959f2b647cf06ae6592a168'
AND (
token = 'AsHN4N0aQficdZRNdf1trvE2ezJYVoaWEZwOEj1D+xg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)