UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VWBZydYfsPWpJQ0yaLRZIavyh/5JEEWPFcSMJeHvuU0='
WHERE
key_id = '230688617bf9fa2268108c17b00990eacf42834ee7a2f86b7de865954a716d4e'
AND (
token = 'VWBZydYfsPWpJQ0yaLRZIavyh/5JEEWPFcSMJeHvuU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)