UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kDz6Skc28yZQ3rRL4TOF7dsY3Mk03jW0VDYH0VrIZdQ='
WHERE
key_id = 'b816edcc03e4dcdea188aa27ea74d6b4bc6b2ec9c6084c56ec6853c25ad368af'
AND (
token = 'kDz6Skc28yZQ3rRL4TOF7dsY3Mk03jW0VDYH0VrIZdQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)