UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DRhw8k9WEKUD8rTYnD+OKQk4Fd22gu400mvcdP2HWtM='
WHERE
key_id = 'a8b81331614caaec0e463f14ef8c8a5e78871cc832aa330877761fd199d60d0a'
AND (
token = 'DRhw8k9WEKUD8rTYnD+OKQk4Fd22gu400mvcdP2HWtM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)