UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DLdCJ++teEz1ZxdTa9FO6xZWOW87426WmMplEcIuJ6I='
WHERE
key_id = '46e2a715821b54f1b37567ab3a25b63e7873805b94c88ec4339981563559af96'
AND (
token = 'DLdCJ++teEz1ZxdTa9FO6xZWOW87426WmMplEcIuJ6I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)