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