UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mpZHzNkFj1C0gsJuyGUDckkhgnhdYw6HQlY2D2jkMtw='
WHERE
key_id = '985f952a9d6d4de14d38effc47f249bdf2309c82c9dabab68de8640a3cca8380'
AND (
token = 'mpZHzNkFj1C0gsJuyGUDckkhgnhdYw6HQlY2D2jkMtw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)