UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R9dqe7hbmSfvTF3FKFRaTNMJqo/AiJP2hygg9sd870s='
WHERE
key_id = 'e2dfa369c43a5f0f552f9bf325075752398c6507adea2da8f4ce291e826efd0c'
AND (
token = 'R9dqe7hbmSfvTF3FKFRaTNMJqo/AiJP2hygg9sd870s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)