UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8+t0KfL8Z9vLw7ELAGCeEWDXan+ofEfE19BHY48Mfhs='
WHERE
key_id = '4c9e5521a0bc993fc68f1024c7165302fb5ceba78c6874078c1822cbfc25fe16'
AND (
token = '8+t0KfL8Z9vLw7ELAGCeEWDXan+ofEfE19BHY48Mfhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)