UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rBviM7pXhf/3lQSLqy35dNsrZIL6/oTcI7yaIiMGYO8='
WHERE
key_id = '1872a1536304c2019615a18f6399d6186af25eedbbbbb015acd8da837ec6bf75'
AND (
token = 'rBviM7pXhf/3lQSLqy35dNsrZIL6/oTcI7yaIiMGYO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)