UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XmoxCcFq45ZvJ/N4XyEb04hZU1krtX5XPS2DmLEH8bs='
WHERE
key_id = '4c04c3df7e07a94fe25b923cd27b50bcbf37f8dbaac0c889269d54187df6bdbb'
AND (
token = 'XmoxCcFq45ZvJ/N4XyEb04hZU1krtX5XPS2DmLEH8bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)