UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Y8bnXadh3EaPWNm5QyQPFa/AjVSbam5f3Dpz3ZpPy8='
WHERE
key_id = '20c144cc3d88ab0a58873e4ee41fc634d7a6ad51bc42eaf2f3ef855cc27dc17a'
AND (
token = '4Y8bnXadh3EaPWNm5QyQPFa/AjVSbam5f3Dpz3ZpPy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)