UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7J7mHaPCNpXGdBu6kGJ+943FH+UWzPO4D85pz5mLPYU='
WHERE
key_id = '87564570025c8b0070aa18acf0c9f2adf85ae7492d1d02a63a2872d6e0ebad63'
AND (
token = '7J7mHaPCNpXGdBu6kGJ+943FH+UWzPO4D85pz5mLPYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)