UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7hp69TgNz0srSHqk3pUSvSAHA1cbuwqoVKDkiEACTGo='
WHERE
key_id = 'fffa9b2ed9591ee525ac46b810d2e6d565b32f7014d35ac4b3926feb6fad52aa'
AND (
token = '7hp69TgNz0srSHqk3pUSvSAHA1cbuwqoVKDkiEACTGo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)