UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jTiPKJZMz5Ha4OKD2ZPIYB6Foj5/Ranac8fGXyQgdLA='
WHERE
key_id = 'e5effebaa34cb887ee87149011906e986c39046ea5a4eb8253d3e81d6c215c30'
AND (
token = 'jTiPKJZMz5Ha4OKD2ZPIYB6Foj5/Ranac8fGXyQgdLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)