UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0KYB+hBWWlGTUQbU8cQNJFJV4NM3eH0zyPkqMiR5ICU='
WHERE
key_id = '5aee729185f92d74bf26d5a1e393cccb2cf14f6f8168473c15fe35eeabbb32ef'
AND (
token = '0KYB+hBWWlGTUQbU8cQNJFJV4NM3eH0zyPkqMiR5ICU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)