UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q7BfJuKka6xA4y/V2X/0fPu2LZMcN3mWhkJmqf1dHgs='
WHERE
key_id = 'b9bc7e345deeef7fa875469feddbbd5c138d36b9439f5a620c7aaaeb071ad78d'
AND (
token = 'q7BfJuKka6xA4y/V2X/0fPu2LZMcN3mWhkJmqf1dHgs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)