UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKqt71vIsctuZD1TPgLtJEu6AoXa3/W/zARihF84dQI='
WHERE
key_id = 'ae5f15be47f11aaa07c1aaedc6858884f9c5242b99f4a2a9a821b03b3afab1ac'
AND (
token = 'zKqt71vIsctuZD1TPgLtJEu6AoXa3/W/zARihF84dQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)