UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0MCw2J86VjpyFFiDElOKJD9pB6HDgWubfrulO+bU2A0='
WHERE
key_id = 'ca201b565d80af132834b61e446233eb7b0ecd9f7a47b1f86130aee6772a933a'
AND (
token = '0MCw2J86VjpyFFiDElOKJD9pB6HDgWubfrulO+bU2A0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)