UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UbN/zj0l6f/eKBciStiQnJ31vfGX6CisvBx9fxwfGhs='
WHERE
key_id = 'b43e131d4d6b124a52a9cd86ec101d2b38ebdfc60b495580ae05ab991c586ca1'
AND (
token = 'UbN/zj0l6f/eKBciStiQnJ31vfGX6CisvBx9fxwfGhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)