UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tp/9JJGR/kxkaWt8YgxoT5XsErpMPs+J9tgunCifQkI='
WHERE
key_id = '7e07b4d29e8e095f7dc589f66436823533de34e3d194cab8de694f847ebea19e'
AND (
token = 'tp/9JJGR/kxkaWt8YgxoT5XsErpMPs+J9tgunCifQkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)