UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oZB5nMvjfTldGPhUpB+0FO8EKGZBpX8z24kt0BPMycg='
WHERE
key_id = 'ab08e88a83c0ea2be7dfc14185c1df215aaed8799e52251c41f031b6cef0fb2e'
AND (
token = 'oZB5nMvjfTldGPhUpB+0FO8EKGZBpX8z24kt0BPMycg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)