UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9kRJtq+h/zoDcD1N+Einy/e0zVx/moZFmC7r+A7grg='
WHERE
key_id = 'abe1e40c35c8674df9feaa7a2e37ee1bc4c183a4b0cf915190464a4c611f4c74'
AND (
token = 'r9kRJtq+h/zoDcD1N+Einy/e0zVx/moZFmC7r+A7grg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)